Postgres Command Line Applications

Postgres CLI tools

Keep this as a general reference. You'll be using these commands quite a lot if you are building web apps with Postgres.

Log in as a particular user

Default installed user is called postgres

sudo -u <username> -i

e.g. sudo -u bob -i

Create a new database

createdb <database_name>

e.g. createdb mydb

Destroy a database

dropdb <database_name>

e.g. dropdb mydb

Reset a database

dropdb <database_name> && createdb <database_name>

e.g. dropdb mydb && createdb mydb

Try it yourself!

Gain technical proficiency in managing postgres databases by practicing creating, dropping, and resetting databases. Do this in your terminal, if you successfully installed Postgres on your local computer, or interact with the terminal in this workspace below, which already has Postgres installed.